Removing Replicate artifacts from the AWS Aurora Cloud for PostgreSQL database

In order to capture DDLs, Qlik Replicate creates various artifacts in the AWS Aurora Cloud for PostgreSQL database when the task starts. When the task completes, you may wish to remove these artifacts.

To remove the artifacts, issue the following statements (in the order they appear below), where public is the default schema in which the artifacts were created:

drop event trigger attrep_intercept_ddl;

Note that the event trigger does not belong to a specific schema.

drop function public.attrep_intercept_ddl()

drop table public.attrep_ddl_audit

drop schema public